{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Calculator","Instructions","Spreadsheet History"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calculator","index":0,"n_rows":85,"n_cols":23,"rows_kept":85,"cut":false,"hidden":false,"merged":[[22,1,23,9],[30,4,30,7],[14,4,14,5],[15,4,15,5],[5,4,5,5],[6,4,6,5],[12,4,12,5],[13,4,13,5],[7,4,7,5],[8,4,8,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[10,4,10,5],[11,4,11,5],[0,0,0,10],[3,4,3,5],[4,4,4,5],[2,4,2,5],[9,4,9,5]]}
["Average Weekly Earnings Calculator",null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2017-05-08T16:13:31.220"},"2006-01-01",null,null,null,"-","weekly",{"$f":"IF(E9=\"weekly\",1,(IF(E9=\"fortnightly\",2,(IF(E9=\"monthly\",3,(IF(E9=\"four weekly\",4,0)))))))","v":1}]
[null,null,null,null,null,null,"Version",{"$f":"MAX('Spreadsheet History'!A:A)","v":"2017-05-08"},{"$f":"MAX('Spreadsheet History'!B:B)","v":4.04},null,null,null,null,null,null,null,"Y",null,"fortnightly",null,null,"employer"]
[null,"Claim number",null,null,null,null,null,null,null,null,null,{"$f":"MAX(B33:B85)","v":0},null,null,null,null,null,null,"monthly",null,null,null,"worker"]
[null,"Employer name",null,null,null,null," Avg. Base wage",null,null,{"$f":"IF(ISNUMBER(P4),ROUND(P4,2),0)","v":0},null,{"$f":"IF(S9> 0, SUM(F33:OFFSET(F33,$L$3-1,0))/S9, 0)","v":0},{"$f":"L4/2","v":0},{"$f":"((L4*12)/365)*7","v":0},{"$f":"L4/4","v":0},{"$f":"OFFSET(L4,,$T$1-1)","v":0},null,null,"four weekly",null,null,null,"case manager"]
[null,"Worker name",null,null,null,null," Avg. Allowance",null,null,{"$f":"IF(ISNUMBER(P5),ROUND(P5,2),0)","v":0},null,{"$f":"IF(S9> 0, SUM(G33:OFFSET(G33,$L$3-1,0))/S9, 0)","v":0},{"$f":"L5/2","v":0},{"$f":"((L5*12)/365)*7","v":0},{"$f":"L5/4","v":0},0,null,null,null,null,null,null,"other"]
[null,"Worker date of birth",null,null,null,null," Avg. Overtime",null,null,{"$f":"IF(ISNUMBER(P6),ROUND(P6,2),0)","v":0},null,{"$f":"IF(S9> 0, SUM(H33:OFFSET(H33,$L$3-1,0))/S9, 0)","v":0},{"$f":"L6/2","v":0},{"$f":"((L6*12)/365)*7","v":0},{"$f":"L6/4","v":0},0]
[null,"End date of last full pay period",null,null,null,null," Avg. Non cash benefit",null,null,{"$f":"IF(ISNUMBER(P7),ROUND(P7,2),0)","v":0},null,{"$f":"IF(S9> 0, SUM(I33:OFFSET(I33,$L$3-1,0))/S9, 0)","v":0},{"$f":"L7/2","v":0},{"$f":"((L7*12)/365)*7","v":0},{"$f":"L7/4","v":0},0]
[null,"Start date of first full pay period",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Pay frequency",null,null,"weekly",null," Average weekly earnings",null,null,{"$f":"SUM(J4:J7)","v":0},null,{"$f":"IF(S9>0, SUM(J33:OFFSET(J33,$L$3-1,0))/S9, 0)","v":0},{"$f":"L9/2","v":0},{"$f":"((L9*12)/365)*7","v":0},{"$f":"L9/4","v":0},0,null,null,{"$f":"SUM(S31:S83)","v":0}]
[null,"Employment type"]
[null,"Avg. hours worked per week",null,null,{"$f":"IFERROR(IF(P29<33,\"\",IF(E9=\"weekly\",AVERAGE(INDIRECT(\"$D$33:$D$\"&P29)),IF(E9=\"fortnightly\",AVERAGE(INDIRECT(\"$D$33:$D$\"&P29))/2,IF(E9=\"four weekly\",AVERAGE(INDIRECT(\"$D$33:$D$\"&P29))/4,SUM(INDIRECT(\"$D$33:$D$\"&P29))/((E7-E8)/7))))),\"\")","v":""}]
[null,"Avg. overtime hours worked per week",null,null,{"$f":"IFERROR(IF(P29<33,\"\",IF(E9=\"weekly\",AVERAGE(INDIRECT(\"$E$33:$E$\"&P29)),IF(E9=\"fortnightly\",AVERAGE(INDIRECT(\"$E$33:$E$\"&P29))/2,IF(E9=\"four weekly\",AVERAGE(INDIRECT(\"$E$33:$E$\"&P29))/4,SUM(INDIRECT(\"$E$33:$E$\"&P29))/((E7-E8)/7))))),\"\")","v":""}]
[null,"Rolling roster?"]
[null,"If yes, please detail roster"]
[null,"Date of Injury"]
[null,"Completed by"]
[]
[]
[null,"FMW weekly rate"]
[null,"FMW hourly rate (if < 38 hours)"]
[null,"FMW category"]
[]
[null,"Claims Agent use only\nThe worker's weekly payments may fall below the Federal Minimum Wage. Please enter the relevant Federal Minimum wage category and rate. (Refer to the FMW Operational Instruction and FMW Table of Rates to determine the correct rate.)"]
[]
[]
[]
[]
[null,null,null,null,null,"Overall Total Base Wage","Overall Total\nAllowances","Overall Total \nOvertime","Overall Total\nNon cash benefit","Overall \nTotal"]
[null,null,null,null,null,{"$f":"IF(S9> 0, SUM(F33:OFFSET(F33,$L$3-1,0)), 0)","v":0},{"$f":"IF(S9> 0, SUM(G33:OFFSET(G33,$L$3-1,0)), 0)","v":0},{"$f":"IF(S9> 0, SUM(H33:OFFSET(H33,$L$3-1,0)), 0)","v":0},{"$f":"IF(S9> 0, SUM(I33:OFFSET(I33,$L$3-1,0)), 0)","v":0},{"$f":"IF(S9> 0, SUM(J33:OFFSET(J33,$L$3-1,0)), 0)","v":0},null,null,null,null,null,{"$f":"COUNTIF(P31:P95,\">0\")+32","v":32}]
[null,null,null,null,null,null,null,null,null,null,null,"weekly","fortnightly","monthly","fourweek","correct date","total","total with -","count","No","Yes"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E7<>\"\",$E7, \"\")","v":""},{"$f":"IF($E7<>\"\",$E7,\"\")","v":""},{"$f":"IF($E7<>\"\",DATE(YEAR($E7), MONTH($E7), DAY(1)), \"\")","v":""},{"$f":"IF($E7<>\"\",$E7, \"\")","v":""},{"$f":"OFFSET(L31,,$T$1-1)","v":""},{"$f":"IF(B33<>\"\",SUM(F33:I33), \"\")","v":""},{"$f":"IF(Q31<>\"\",IF(D33<>\"Y\", Q31, \"-\"),\"\")","v":""},{"$f":"IF(R31<>\"\", IF(R31=\"-\",0,1),\"\")","v":""}]
[null,"Period","Pay Date","Hours worked","Overtime Hours","Base wage","Allowances","Overtime","Non cash benefit","Total",null,{"$f":"IF(L31<>\"\",IF(L31-7>$E$8+5,L31-7,\"\"),\"\")","v":""},{"$f":"IF(M31<>\"\",IF(M31-14>$E$8+12,M31-14,\"\"),\"\")","v":""},{"$f":"IF(N31<>\"\",IF(DATE(YEAR(N31), MONTH(N31)-1, DAY(N31))>=$E$8,DATE(YEAR(N31), MONTH(N31)-1, DAY(N31)),\"\"),\"\")","v":""},{"$f":"IF(O31<>\"\",IF(O31-28>$E$8+26,O31-28,\"\"),\"\")","v":""},"","","",{"$f":"IF(R32<>\"\", IF(R32=\"-\",0,1),\"\")","v":""}]
[null,{"$f":"IF(C33<>\"\", 1, \"\")","v":""},{"$f":"P31","v":""},0,0,0,0,0,0,{"$f":"R31","v":""},null,{"$f":"IF(L32<>\"\",IF(L32-7>$E$8+5,L32-7,\"\"),\"\")","v":""},{"$f":"IF(M32<>\"\",IF(M32-14>$E$8+12,M32-14,\"\"),\"\")","v":""},{"$f":"IF(N32<>\"\",IF(DATE(YEAR(N32), MONTH(N32)-1, DAY(N32))>=$E$8,DATE(YEAR(N32), MONTH(N32)-1, DAY(N32)),\"\"),\"\")","v":""},{"$f":"IF(O32<>\"\",IF(O32-28>$E$8+26,O32-28,\"\"),\"\")","v":""},"","","",""]
[null,{"$f":"IF( C34 <> \"\", B33+1, \"\")","v":""},"",0,0,0,0,0,0,{"$f":"R32","v":""},null,"","","","","","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","","","","","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","","","","","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","","","","","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","","","","","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","","","","","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","","","","","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","","","","","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","","","","","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","",{"$f":"\"\"","v":""},"","","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"","",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"",{"$f":"IF(B65<>\"\",SUM(F65:I65), \"\")","v":""},{"$f":"IF(Q63<>\"\",IF(D65<>\"Y\", Q63, \"-\"),\"\")","v":""},""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"",{"$f":"P63","v":""},0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,"",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","","",""]
[null,"","",0,0,0,0,0,0,"",null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"","",""]
[null,"","",0,0,0,0,0,0,""]
[null,"","",0,0,0,0,0,0,{"$f":"R83","v":""}]

{"sheet":"Instructions","index":1,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[[8,1,8,7],[11,1,11,7],[0,0,0,9],[1,2,1,9],[4,1,4,7],[5,1,5,7],[2,1,2,8],[6,1,6,7],[10,1,10,7],[9,1,9,7],[12,1,12,7],[15,2,15,8],[19,2,19,8],[16,2,16,7],[17,2,17,7],[13,2,13,7],[25,2,25,9],[27,2,27,9],[29,2,29,9],[14,2,14,7],[18,2,18,7],[21,2,21,7]]}
["Average Weekly Earnings Calculator",null,null,null,null,null,null,null,null,null,null,""]
[]
[null,"INSTRUCTIONS  (NOTE this spreadsheet must be saved locally and opened in Excel)"]
[]
[null,"The calculator is useful when a worker has earned different amounts each week and it is necessary to determine a weekly rate that reflects an average over the preceding 12 months, or lesser period if appropriate. "]
[null,"Before using the calculator it is necessary to identify what amounts are included and excluded from the calculation of AWE."]
[null,"1. Enter the following details at the top of the sheet:\n   -  Claim number\n   -  Employer name \n   -  Worker name \n   -  Worker birth date (dd/mm/yyyy)\n   -  The end date of the last full pay period (dd/mm/yyyy)\n   -  The start date of the first full pay period (dd/mm/yyyy) i.e. the day after the last pay day\n   -  Pay frequency (weekly, fortnightly, monthly, four weekly)\n   -  Employment type (full time, part time, casual)\n   -  Rolling roster (yes/no)\n   -  Roster detail where applicable\n   -  The date of injury (dd/mm/yyyy)\n   -  Completed by"]
[null,"2. Enter the hours worked, overtime hours, base wage, allowances, overtime and non-cash benefit values."]
[null,"Please note:  A value must be entered for each pay period, even if the value is $0 (nil). The results from this calculator should be used as guide only. \nThe AWE calculator contains macros and a full installation of Microsoft Excel is needed. To use the calculator, macros must be enabled. "]
[null,"3. Once completed, if there is a Federal Minimum Wage (FMW) Flag (red text above notes and Average weekly earnings highlighted in red) complete the following details: \n   -  FMW weekly rate\n   -  FMW hourly rate\n   -  FMW category\n"]
[null,"Please note:  Further investigation will be required if there is a FMW flag. Refer to the FMW Operational Instruction and FMW Table of Rates to determine the correct rate."]
[null,"4. Once completed, save the file."]
[null,"HELPFUL DEFINITIONS"]
[null,"The start date of the first full pay period ","This is the first day of a full pay period. For example if payed weekly on a Friday this date would be a Saturday regardless of the number of days a week they work."]
[null,"Average weekly \nearnings","The amount that the worker earned during the period of 12 months preceding the date of injury (or lesser period if appropriate). Refer to section 5 of the Return To Work Act 2014 for further details on what components to be included and excluded."]
[null,"Base Wage: ","The Gross (before tax) Weekly Salary - including\n\n- any amount paid while the worker was on annual, sick or other leave \n- and any amount that has been the subject of a voluntary salary sacrifice, by the worker, including\n  salary sacrifice for superannuation purposes. \n- shift allowance  \n- Penalty rates \n- leave loading \nPlease note: this does not include any contribution paid or payable by the employer to a superannuation scheme for the benefit of the worker.\n \n"]
[null,"Allowances:  ","Exclude: Allowances paid occasionally or intermittently to the worker for accommodation or travel where -\n(a) the worker's accommodation or means of travel is not otherwise provided by the employer; or\n(b) the cost of the worker's accommodation or travel is not otherwise reimbursed by the employer.\n\nInclude: Other allowances paid by the employer to the worker, e.g. uniform allowance or working at height allowance.  \nPlease note: the case manager will need evidence of the payment of any allowance for the period relevant to the calculation of Average Weekly Earnings.\n\n"]
[null,"Overtime:","Overtime is the time worked in addition to a worker's usual hours of employment (refer to section 5(12) of the Return To Work Act 2014). For example: a worker might work a full 7.6 hour day, then continue to work for a further two hours. The additional two hours may be classed as overtime, depending on the terms of any relevant award or industrial agreement. "]
[null,null,"Overtime is to be included in the AWE calculation if the worker worked overtime during the 12 months preceding the injury (or lesser period if appropriate) and the worker has reasonable expectation that it would continue in the foreseeable future."]
[null,"Non cash benefit: ","Any non-cash benefit received by the worker as part of remuneration, eg, a company vehicle or mobile phone.  Please note:  a non-cash benefit will not be included in Average Weekly Earnings if the benefit is retained.  Evidence of the benefit and the equivalent weekly monetary value must be provided to the Case Manager."]
[null,"Average weekly earnings do not include:"]
[null,null,"- employer contributions to a scheme for superannuation benefits (other than contributions made from money payable to the worker) "]
[null,null,"- overtime if it was not reasonably expected to continue."]
[null,null,"- non Cash Benefits that are retained by the worker"]
[]
[null,"FMW weekly rate","To be used if the worker’s average weekly hours are equal to or above 38 hours. This rate will directly correspond to the relevant FMW category."]
[]
[null,"FMW hourly rate","To be used if the worker’s average weekly hours less than 38 hours. This rate will directly correspond to the relevant FMW category."]
[]
[null,"FMW category rate","Further investigation will be required to determine the correct FMW category. The relevant categories can be found on the FMW Table of Rates. Please refer to the FMW Operational Instruction to determine the correct rate."]

{"sheet":"Spreadsheet History","index":2,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["Date","Version","Author","Changes"]
["2008-07-01",1,"Jason Cunningham","Initial version"]
["2008-07-17",2,"Graham Kirkman","Remove the date picker form from the spreadsheet as this was causing compatability issues with external users."]
["2008-04-30",2.0099999999999998,"Graham Kirkman","Fixed issue with average calculations. Offset had col 1 not col 0."]
["2008-06-23",2.0110000000000001,"Graham Kirkman","Users found that they weren't able to print the instructions."]
["2008-07-03",2.012,"Graham Kirkman","Change the instructions to reflect that there is no longer a form to fill out."]
["2008-07-03",2.0129999999999999,"Graham KIrkman","Change the instructions to inform the user that the sheet should be opened in Excel."]
["2008-07-15",2.0139999999999998,"Graham KIrkman","Allow copying of protected cells, also ensure that the cell is protected when LWP = Y."]
["2008-07-24",2.0150000000000001,"Graham KIrkman","Pay periods can only be for a max of 1 standard year (52 weeks, 26 fortnights, 13 4 weekly & 12 monthly)."]
["2008-08-22",2.016,"Neil Moorcroft","Request 65493 - Remove line from Instructions worksheet"]
["2009-01-16",2.0169999999999999,"Rimas Sestokas","LWP column has been hidden and instructions have been modified."]
["2009-03-24",3,"Rimas Sestokas","Added text box for user comment, drop down to select who completed the form, and GST Input Tax Credit field"]
["2009-11-27",3.01,"Rimas Sestokas","Added Date of Injury field. Also added some validation code to ensure that DOI could not be within the entered pay period."]
["2011-06-30",3.02,"Heidrun Richter","Protect Calculator tab and change description of Base wage section and Allowances section.\nCO8081 - Req106587 and Inc106651"]
["2011-08-31",3.03,"Heidrun Richter","CO8255 - add overall total for the entered figures"]
["2011-09-19",3.04,"Heidrun Richter","CO8255 - fix the logic getting the overall total for the entered figures"]
["2013-04-22",3.05,"Steve Hammond","Req 119084 - Reorder data entry to reflect Curam"]
["2013-10-23",3.06,"Nandita Mazumdar","Req 124983 - Add two new fields related to \"rolling Roster\""]
["2014-05-05",3.07,"Steve Mitchell","Remove references to employer Input tax credit and ITC entry cell - Does not change calculations and can confuse employers.  For this reason the ITC field was removed from the ERF. Des Quirk Director Financial Services authorised"]
["2014-09-11",3.08,"Nandita Mazumdar","Case 10250 - updated the definition of Average Weekly Earnings, in the Instructions tab of the AWE calculator, by removing the current definition and replacing it with - \"The amount that the worker earned during the period of 12 months preceding the date of injury (or lesser period if appropriate). Refer to section 4 of the Workers Rehabilitation and Compensation Act for further details on what components to be included and excluded.\""]
["2015-04-08",3.09,"Steve Hammond","Amended date validation VBA as previously adding the 2 new rolling roster rows  (see Version 3.060) caused code to break"]
["2015-04-08",4,"Steve Hammond","Calculator updated for changes wef 01/07/2015"]
["2015-05-26",4.01,"Steve Hammond","Added new fields for Employment type and Hours worked per week as requested by Agents.\nAdded 3 new Federal Minimum Wage (FMW) fields as requested by Krystal McBride."]
["2015-06-23",4.0199999999999996,"Steve Hammond","Added new fields for Overtime Hours and Average Overtime Hours per week as requested by Agents.\nCorrected formula for average hours worked per week based on pay frequency."]
["2015-06-30",4.03,"Steve Hammond","Amended the Federal Minimum Wage rate for 2015 to $1026.40"]
["2017-05-08",4.04,"Nandita Mazumdar","Case 94535 - fixed text box font size issue"]